package com.lottery.www.dao;

import com.lottery.www.entity.UserAccount;
import com.github.yulichang.base.MPJBaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author leo
 * @since 2023-06-08 11:14:48
 */
@Repository("userAccountDao")
public interface UserAccountDao extends MPJBaseMapper<UserAccount> {

    @Select("select pay_count,accid,win_pay_count from user_account where date_format(create_time,'%Y%m%d')=date_format(now(),'%Y%m%d') order by create_time asc limit 1")
    public UserAccount findAccFirst();

}
